﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'GetNaturalByDNI')
	BEGIN
		DROP  Procedure  GetNaturalByDNI
	END
GO

CREATE Procedure GetNaturalByDNI
	@DNI char(8)
AS

BEGIN

	SELECT * FROM Natural WHERE DNI LIKE (@DNI+'%')

END

GO


GRANT EXEC ON GetNaturalByDNI TO PUBLIC

GO

